SAP MAX DBΒΆ
version: 1.0
Compatibility: v 7.5.3
Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Metric Collect Interval (Second)
Operation: monitors the SAP Max DB.
Plugin-Metrics:
Metric |
Data Type |
Connection Time (MS) |
Numeric |
Kernel Version |
String |
Running Directory |
String |
Instance Type |
String |
Sequence Cache (MB) |
Numeric |
Catalog Cache (MB) |
Numeric |
OMS Heap (MB) |
Numeric |
Shared SQL Cache (MB) |
Numeric |
Used Data (KB) |
Numeric |
Total Data (KB) |
Numeric |
Used Temporary Converter (KB) |
Numeric |
Incremental Backup (KB) |
Numeric |
Used Permanent Data (KB) |
Numeric |
Used Temporary Data (KB) |
Numeric |
Used Shadow Data (KB) |
Numeric |
Used Permanent Converter (KB) |
Numeric |
Used Data (%) |
Numeric |
Free Data (%) |
Numeric |
Free Data (KB) |
Numeric |
Used Log (MB) |
Numeric |
Total Log (MB) |
Numeric |
Used Log (%) |
Numeric |
Log Area Full |
String |
Logging Status |
String |
Log Auto Overwrite |
String |
Log Flush Mode |
String |
Log Device State |
String |
Log Writer Status |
String |
IO Buffer File Directory (KB) |
Numeric |
IO Buffer Block Allocator (KB) |
Numeric |
IO Buffer Converter Used (KB) |
Numeric |
IO Buffer Log Queue Cache (KB) |
Numeric |
IO Buffer Index Creation (KB) |
Numeric |
IO Buffer Cache (KB) |
Numeric |
IO Buffer Data Cache (KB) |
Numeric |
IO Buffer Management (KB) |
Numeric |
IO Buffer Unused (KB) |
Numeric |
Changed Data Cache (KB) |
Numeric |
OMS Data Cache (KB) |
Numeric |
SQL Data Cache (KB) |
Numeric |
History Data Cache (KB) |
Numeric |
Used Pin Area Data Cache (KB) |
Numeric |
SQL Request Timeout Locks |
Numeric |
Used Locks |
Numeric |
Lock Escalations |
Numeric |
Dead Locks |
Numeric |
OMS Lock Collisions |
Numeric |
Row Locks |
Numeric |
Maximum Locks |
Numeric |
SQL Lock Collisions |
Numeric |
Used Entry Locks (%) |
Numeric |
OMS Request Timeout Locks |
Numeric |
Table Locks |
Numeric |
Latest Backup Thread ID |
String |
Latest Backup Thread Name |
String |
Automatic Log Backup |
String |
Latest Backup IO Count |
Numeric |
Latest Backup IO Page Count |
Numeric |
Latest Backup Pending IO Count |
Numeric |
Latest Backup Path |
String |
Latest Backup IO Time (MS) |
Numeric |
Instance Columns:
Cache Statistic
Metric |
Data Type |
Cache Statistic |
String |
Unsuccessful Access |
Numeric |
Successful Access |
Numeric |
Access |
Numeric |
Hit Rate (%) |
Numeric |
Data Volume
Metric |
Data Type |
Data Volume |
String |
Data Volume (MB) |
Numeric |
Used Data Volume (MB) |
Numeric |
Used Data Volume (%) |
Numeric |
Data Volume Path |
String |
Log Volume
Metric |
Data Type |
Log Volume |
String |
Log Volume (MB) |
Numeric |
Used Log Volume (MB) |
Numeric |
Log Volume Path |
String |
Used Log Volume (%) |
Numeric |
Schema
Metric |
Data Type |
Schema |
String |
Schema Used (KB) |
Numeric |
Total Tables |
Numeric |
OMS Heap Allocator
Metric |
Data Type |
OMS Heap Allocator |
String |
OMS Heap Used (KB) |
Numeric |
OMS Max Heap Usage (KB) |
Numeric |
OMS Reserved Heap Memory (KB) |
Numeric |
Resource Monitor ID
Metric |
Data Type |
Resource Monitor ID |
String |
SQL Query |
String |
Called Count |
Numeric |
Qualified Rows |
Numeric |
Virtual Reads |
Numeric |
Rows Fetched |
Numeric |